翻訳と辞書 Words near each other ・ Pivot Legal Society ・ Pivot Peak ・ Pivot point ・ Pivot point (technical analysis) ・ Pivot shear ・ Pivot table ・ Pivot turn ・ Pivot turn (skiing) ・ Pivot Wireless ・ Pivot-shift test ・ Pivotal ・ Pivotal (horse) ・ Pivotal altitude ・ Pivotal CRM ・ Pivotal Games ・ Pivotal Greenplum Database ・ Pivotal Labs ・ Pivotal quantity ・ Pivotal response therapy ・ Pivotal Rockordings ・ Pivotal Software ・ Pivotal trial ・ PivotLink ・ PivotNorth Capital ・ PivotPoint Technology Corporation ・ PivotX ・ Pivovar Eggenberg ・ Pivovar Kocour Varnsdorf ・ Pivovara Ličanka ・ Pivoxazepam Dictionary Lists mini英和辞書 mini和英辞書 Webster 1913 Latin-English FOLDOC Wikipedia English ウィキペディア

翻訳と辞書　辞書検索 [ 開発暫定版 ] スポンサード リンク Pivotal Greenplum Database ： ウィキペディア英語版 Pivotal Greenplum Database Pivotal Greenplum Database is a database software developed by Pivotal Software, Inc. (Pivotal). It was originally developed by Greenplum which was acquired by EMC Corporation in July 2010 and spun out into Pivotal Software in 2013. ==System Overview== Pivotal Greenplum Database is a MPP (massively parallel processing) database built on open source PostgreSQL. The system consists of a master node, standby master node, and segment nodes. All of the data resides on the segment nodes and the catalog information is stored in the master nodes. Segment nodes run one or more segments, which are modified PostgreSQL database instances and are assigned a content identifier. For each table the data is divided among the segment nodes based on the distribution column keys specified by the user in the DDL statement. For each segment content identifier there is both a primary segment and mirror segment which are not running on the same physical host. When a SQL query enters the master node, it is parsed, optimized and dispatched to all of the segments to execute the query plan and either return the requested data or insert the result of the query into a database table. Bulk loading and unload is also supported directly to the segment nodes, bypassing the master nodes and can read and write external data from ETL nodes, flat files, or HDFS file systems residing outside of the Greenplum cluster. Greenplum is known for fast parallel data loading/unloading as well as fast internal data transfer for operations such as CTAS (Create Table as Select). Greenplum supports ACID principles of transaction management for concurrent data access and modification, allowing it to be a system of record database, but is optimized for analytical database workloads as opposed to OLTP workloads. SQL language, SQL:2003 standard, is the interface to the data in Greenplum. User defined functions can be written in languages such as Python, R, Perl, Java, C, or pgSQL and called from within a SQL query. 抄文引用元・出典: フリー百科事典『 ウィキペディア（Wikipedia）』 ■ウィキペディアで「Pivotal Greenplum Database」の詳細全文を読む スポンサード リンク 翻訳と辞書 : 翻訳のためのインターネットリソース Copyright(C) kotoba.ne.jp 1997-2016. All Rights Reserved.